package com.lxl.jpa;

import com.lxl.entity.InterfaceAuthEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface InterfaceAuthJPA extends JpaRepository<InterfaceAuthEntity, Long> {
    @Query(value = "SELECT * FROM \"ETL_InterfaceAuth\" WHERE \"interfaceCategory\" = ?1 " +
            "AND \"cusCode1\"=?2 AND \"status\" = \'1\'",nativeQuery = true)
    List<InterfaceAuthEntity> selectInterfaceAuthFromTypeAndName(String type, String name);
}
